// Listing 7-14
CREATE VIEW viwUserManContacts AS
  SELECT CONVERT(nvarchar(30), "urn:schemas:contacts:givenname") AS FirstName,
         CONVERT(nvarchar(30), "urn:schemas:contacts:sn") AS LastName,
         CONVERT(nvarchar(50), "urn:schemas:contacts:email1") AS Email
  FROM OpenQuery(EXCHANGE, 'SELECT 
         "urn:schemas:contacts:givenname",
         "urn:schemas:contacts:sn", 
         "urn:schemas:contacts:email1"
     FROM SCOPE(''shallow traversal of "./Contacts"'')')